<?php
/**
 * 基础物料保质期明细流水单据
 *
 * @author kamisama.xia@gmail.com 
 * @version 0.1
 */

$db['basic_material_storage_life_bills']=array (
  'columns' =>
  array (
    'bmslb_id' =>
    array (
      'type' => 'int unsigned',
      'required' => true,
      'pkey' => true,
      'extra' => 'auto_increment',
      'label' => 'ID',
      'width' => 110,
      'hidden' => true,
      'editable' => false,
    ),
    'bmsl_id' =>
    array (
      'type' => 'int unsigned',
      'required' => true,
      'width' => 110,
      'hidden' => true,
      'editable' => false,
    ),    
    'bm_id' =>
    array (
      'type' => 'int unsigned',
      'required' => true,
      'width' => 110,
      'hidden' => true,
      'editable' => false,
    ),
    'material_bn' =>
    array (
	  'type' => 'varchar(200)',
      'label' => '物料编码',
      'width' => 120,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
      'required'        => true,
    ),
    'material_bn_crc32' =>
    array (
      'type' => 'bigint(13)',
      'label' => '货号查询索引值',
      'editable' => false,
      'required'        => true,
    ),
    'expire_bn' =>
    array (
      'type' => 'varchar(200)',
      'label' => '物料保质期编码',
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
      'required'        => true,
    ),
    'nums'=>
    array(
      'type'=>'mediumint(8)',
      'label' => '数量',
      'editable' => false,
      'default'         => 0,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'branch_id' =>
    array (
      'type' => 'number',
      'label' => '仓库ID',
      'required' => true,
      'editable' => false,
    ),
    'bill_id' => array(
        'type' => 'int unsigned',
        'label' => '关联单据ID',
        'hidden' => true,
        'default' => 0,
        'editable' => false,
        'required' => true,
    ),
    'bill_bn' => array(
        'type' => 'varchar(50)',
        'label' => '关联单据单号',
        'hidden' => true,
        'editable' => false,
        'required' => true,
    ),
    'bill_type' => array(
        'type' => 'tinyint(1)',
        'label' => '关联单据类型',
        'hidden' => true,
        'editable' => false,
        'required' => true,
    ),
    'bill_io_type' => array(
        'type' => 'tinyint(1)',
        'label' => '单据出入类型',
        'hidden' => true,
        'editable' => false,
        'required' => true,
    ),
  ),
  'comment' => '基础物料保质期明细流水单据',
  'engine' => 'innodb',
  'version' => '$Rev:  $',
);
